<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_store_inout_note`;");
E_C("CREATE TABLE `ecs_store_inout_note` (
  `note_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `inout_rec_id` int(10) unsigned NOT NULL COMMENT '对应表格ecs_store_inout_list里的rec_id字段',
  `adminer_id` smallint(5) unsigned NOT NULL,
  `action_val` varchar(255) NOT NULL COMMENT '保存“操作说明（如：提交审核）”',
  `inout_status` tinyint(1) unsigned NOT NULL,
  `inout_note` varchar(255) NOT NULL,
  `add_time` int(10) unsigned NOT NULL,
  `supplier_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '入驻商店铺id',
  `store_type_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '仓库类型id',
  PRIMARY KEY (`note_id`),
  KEY `supplier_id` (`supplier_id`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='出入库备注信息'");
E_D("replace into `ecs_store_inout_note` values('1','1','4','提交审核','2','沈阳入库','1418349722','0','0');");
E_D("replace into `ecs_store_inout_note` values('2','2','7','提交审核','2','请审核','1418349927','0','0');");
E_D("replace into `ecs_store_inout_note` values('3','2','6','通过审核','3','OK','1418349981','0','0');");
E_D("replace into `ecs_store_inout_note` values('4','3','7','提交审核','2','请审核','1418350315','0','0');");
E_D("replace into `ecs_store_inout_note` values('5','3','1','通过审核','3',';;','1418350412','0','0');");
E_D("replace into `ecs_store_inout_note` values('6','1','1','通过审核','3','//','1418350433','0','0');");
E_D("replace into `ecs_store_inout_note` values('7','4','4','提交审核','2','沈阳入库','1418350441','0','0');");
E_D("replace into `ecs_store_inout_note` values('8','4','5','通过审核','3','OK','1418350479','0','0');");
E_D("replace into `ecs_store_inout_note` values('9','10','7','提交审核','2','请审核','1418352130','0','0');");
E_D("replace into `ecs_store_inout_note` values('10','9','7','提交审核','2','','1418352134','0','0');");
E_D("replace into `ecs_store_inout_note` values('11','9','6','审核备注','3','1','1418352151','0','0');");
E_D("replace into `ecs_store_inout_note` values('12','10','6','审核备注','3','1','1418352156','0','0');");
E_D("replace into `ecs_store_inout_note` values('13','18','14','提交审核','2','1','1418354368','18','18');");
E_D("replace into `ecs_store_inout_note` values('14','18','14','审核备注','3','1','1418354372','18','18');");
E_D("replace into `ecs_store_inout_note` values('15','19','1','提交审核','2','1','1418354492','18','18');");
E_D("replace into `ecs_store_inout_note` values('16','19','1','审核备注','3','1','1418354497','18','18');");
E_D("replace into `ecs_store_inout_note` values('17','24','4','提交审核','2','','1418364508','0','0');");
E_D("replace into `ecs_store_inout_note` values('18','24','5','通过审核','3','','1418364584','0','0');");
E_D("replace into `ecs_store_inout_note` values('19','28','19','提交审核','2','请审核','1418368728','22','22');");
E_D("replace into `ecs_store_inout_note` values('20','28','19','通过审核','3','OK','1418368738','22','22');");
E_D("replace into `ecs_store_inout_note` values('21','29','1','提交审核','2','请审核！','1418368834','22','22');");
E_D("replace into `ecs_store_inout_note` values('22','29','1','拒绝审核','4','不予审核！','1418368857','22','22');");
E_D("replace into `ecs_store_inout_note` values('23','30','1','提交审核','2','亲审核','1418369060','22','22');");
E_D("replace into `ecs_store_inout_note` values('24','30','1','退回','1','','1418369194','22','22');");
E_D("replace into `ecs_store_inout_note` values('25','31','1','提交审核','2','','1418369214','22','22');");
E_D("replace into `ecs_store_inout_note` values('26','31','1','通过审核','3','','1418369231','22','22');");
E_D("replace into `ecs_store_inout_note` values('27','33','19','提交审核','2','请审核','1418369873','22','22');");
E_D("replace into `ecs_store_inout_note` values('28','32','19','提交审核','2','请快速审核','1418369896','22','22');");
E_D("replace into `ecs_store_inout_note` values('29','33','19','审核备注','3','','1418369902','22','22');");
E_D("replace into `ecs_store_inout_note` values('30','32','19','审核备注','3','OK','1418369909','22','22');");
E_D("replace into `ecs_store_inout_note` values('31','34','19','提交审核','2','','1418370389','22','22');");
E_D("replace into `ecs_store_inout_note` values('32','34','19','审核备注','3','','1418370394','22','22');");
E_D("replace into `ecs_store_inout_note` values('33','35','1','提交审核','2','请审核','1418370547','0','0');");
E_D("replace into `ecs_store_inout_note` values('34','37','1','提交审核','2','','1418370717','0','0');");
E_D("replace into `ecs_store_inout_note` values('35','37','1','通过审核','3','','1418370767','0','0');");
E_D("replace into `ecs_store_inout_note` values('36','38','1','提交审核','2','dfddfgf','1418372789','0','0');");
E_D("replace into `ecs_store_inout_note` values('37','40','19','提交审核','2','','1418373068','22','22');");
E_D("replace into `ecs_store_inout_note` values('38','40','19','通过审核','3','','1418373078','22','22');");

require("../../inc/footer.php");
?>